PLEASE NOTE:  
some of the material is not how I would normally do some things.  They were done for illustrative 
puposes only, to show different functionality or to illustrate a point.



For this to work in your environment.....

Create Database in SQL Server: MDN_Reporting.
(if another name used, all references in Excel, SSIS, etc. need changed).

Run Scripts to Create Tables, Views and Stored Procedures in SQL Server.

Create ODBC System DSN using:
SQL Native Client 10.0 (SQL Server 2008) 
or
SQL Native Client (SQL Server 2005) 
and reference MDN_Reporting database (or other database); see accompanying Word document:
KC Office Geeks - Dynamic Excel Reporting - Excel Data Connections.docx.

The Connection Managers for "Flat File Connections" in SSIS project will need to be changed to
reference location of files:
BillingData.csv file; data loaded from this .csv file into the dbo.Billing table,
ServiceData.csv file; data loaded from this .csv file into the dbo.Service table.

Server, SQL Named Instance and database needs to be changed in VBA for Excel file.

Linked objects in PowerPoint need to be changed to Where the Excel file resides:
KC Office Geeks - Dynamic Excel Reporting - PivotTable Example - SQL08
or
KC Office Geeks - Dynamic Excel Reporting - PivotTable Example - SQL05

For PowerPoint 2007:
Click on Office Button (uppermost left)
Click on Prepare
Click on "Edit Links to Files"
Click on any item
Click on Change Source
Browse to where Excel file is located and double click on file.
(If file location has changed or other reasons, new links may need to be cut and pasted.)

For PowerPoint 2003:
Click on Edit in menu
Click on Links
Click on any item
Click on Change Source
Browse to where Excel file is located and double click on file.
(If file location has changed or other reasons, new links may need to be cut and pasted.)